$obj->save() == false return "serial is required"

Question

$obj->save() == false return "serial is required"

engsere Mar '15

Created Mar '15	Last Reply Feb '16	Replies 3	Views 682	Votes 0

engsere 7.6k

Mar '15

hi,

i have simply code:

PostgreSQL:

> CREATE TABLE comments

> (

> id serial NOT NULL,

> owner integer,

> type character(1),

> created timestamp without time zone,

> message text,

> CONSTRAINT comments_pkey PRIMARY KEY (id)
> )

model is autogenerated and Controller:

> 
> $comment= new Comments();

> $comment->message=$msg;

> $comment->owner=$uid;

> $comment->type=$type;

> $comment->created=date('Y-m-d h:i:s.u');

> 

> if ($comment->save() == false) {

> 

>     foreach ($comment->getMessages() as $value) {

>         echo $value.'; \n';

>     }

> }

return this: id is required

someone know why? other saves to tables work fine...

using Phalcon DevTools (1.3.4)

Julián Arturo Molina Castiblanco · Answer 1 · 2015-03-23T12:53:21-07:00

Ok im had the same error, occur when you have two columns of serial type or when you have two default value column with some sequence added, also you set null to id, ex: $comment->id = null;

engsere · Answer 2 · 2015-03-23T14:29:30-07:00

ok, but i have only one autoincremented column... nothing else... simpliest from simpliest :P

Julián Arturo Molina Castiblanco · Answer 3 · 2015-03-23T15:07:57-07:00

Check if this serial was created sequence, something like php comment_id_seq and this seq and if really increment it value, also verify the column id if was add default value something like:

nextval('name_seq_comments_id_seq'::regclass)

Julián Arturo Molina Castiblanco · Answer 4 · 2015-03-23T15:10:02-07:00

Julián Arturo Molina Castiblanco
3.5k

Mar '15

do you use PgAdmin?

engsere · Answer 5 · 2015-03-24T02:22:42-07:00

thank for replay. Actualy i havent access to DB, i check afternoon.

Yes, i using PgAdmin, why?